ALTER TABLE public.product_ogclink
    add column "intTest" integer, add column "floatTest" float, add column "booleanTest" boolean, add column "dateTest" date, add column "varcharTest" varchar;
ALTER TABLE public.product add column "extraProperties" json;
-- product data, without geometries
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution", "eoProductPlatform", "keywords")
VALUES(352, '2016-09-29 10:20:22.026', '2016-09-29 10:23:44.107', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160929T154211_A006640_T32TPP_N02.04', 'SENTINEL2', 'ARCHIVED', 'NOMINAL', 65, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2016-09-29 18:59:02.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sentinel-2a', '{"k1", "k2", "k3"}');
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution", "assets")
VALUES(353, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T32TPL_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
'{"thumbnail":{"title":"Thumbnail","href":"https://roda.sentinel-hub.com/sentinel-s2-l1c/tiles/9/V/XK/2017/10/13/0/preview.jpg"},"info":{"title":"Basic JSON metadata","href":"https://roda.sentinel-hub.com/sentinel-s2-l1c/tiles/9/V/XK/2017/10/13/0/tileInfo.json"},"metadata":{"title":"Complete XML metadata","href":"https://roda.sentinel-hub.com/sentinel-s2-l1c/tiles/9/V/XK/2017/10/13/0/metadata.xml"},"tki":{"title":"True color image","type":"image/jp2","eo:bands":[3,2,1],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/TKI.jp2"},"B01":{"title":"Band 1 (coastal)","type":"image/jp2","eo:bands":[0],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B01.jp2"},"B02":{"title":"Band 2 (blue)","type":"image/jp2","eo:bands":[2],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B02.jp2"},"B03":{"title":"Band 3 (green)","type":"image/jp2","eo:bands":[2],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B03.jp2"},"B04":{"title":"Band 4 (red)","type":"image/jp2","eo:bands":[3],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B04.jp2"},"B05":{"title":"Band 5","type":"image/jp2","eo:bands":[4],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B05.jp2"},"B06":{"title":"Band 6","type":"image/jp2","eo:bands":[5],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B06.jp2"},"B07":{"title":"Band 7","type":"image/jp2","eo:bands":[6],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B07.jp2"},"B08":{"title":"Band 8 (nir)","type":"image/jp2","eo:bands":[7],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B08.jp2"},"B8A":{"title":"Band 8A","type":"image/jp2","eo:bands":[8],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B08.jp2"},"B09":{"title":"Band 9","type":"image/jp2","eo:bands":[9],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B09.jp2"},"B10":{"title":"Band 10 (cirrus)","type":"image/jp2","eo:bands":[10],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B10.jp2"},"B11":{"title":"Band 11 (swir16)","type":"image/jp2","eo:bands":[11],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B11.jp2"},"B12":{"title":"Band 12 (swir22)","type":"image/jp2","eo:bands":[12],"href":"https://sentinel-s2-l1c.s3.amazonaws.com/tiles/9/V/XK/2017/10/13/0/B11.jp2"}}'
);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(354, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T32TPM_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(355, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T32TPN_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(356, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T32TQL_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(357, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T32TQM_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(358, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T32TQN_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 11, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(359, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TTF_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(360, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TTG_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(361, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TUF_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(362, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TUG_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 32, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(363, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TUH_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 68, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(364, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TVF_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 12, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(365, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TVG_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 57, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(366, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TVH_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 56, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(367, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TWG_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(368, '2016-01-17 10:10:30.743', '2016-01-17 10:10:30.743', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T33TWH_N02.01', 'SENTINEL2', NULL, 'NOMINAL', 122, 'DESCENDING', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '2016-01-18 21:05:18.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution", "eoProductPlatform")
VALUES(369, '2017-03-08 18:54:21.026', '2017-03-08 18:54:21.026', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_MTI__20170308T220244_A008933_T11SLT_N02.04', 'SENTINEL2', NULL, 'NOMINAL', 70, 'DESCENDING', NULL, NULL, NULL, 7, NULL, NULL, NULL, NULL, NULL, '2017-03-08 18:54:20.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sentinel-2a');
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution")
VALUES(370, '2017-02-26 10:20:21.026', '2017-02-26 10:30:00.031', NULL, NULL, NULL, 'S2A_OPER_MSI_L1C_TL_SGS__20170226T171842_A008785_T32TPN_N02.04', 'SENTINEL2', NULL, 'NOMINAL', 65, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2017-02-26 10:24:58.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution", "atmSpecies", "atmVerticalRange","assets", "extraProperties")
VALUES(1, '2018-02-26 10:20:21.000', '2018-02-26 10:20:21.000', NULL, NULL, NULL, 'SAS1_20180226102021.01', 'SAS1', NULL, 'NOMINAL', 55, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2017-02-26 10:24:58.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ARRAY['O3', 'O3', 'CO2'], ARRAY[1000, 2000, 0],'{"thumbnail":{"title":"the_title"},"thumbnail2":{"title":"the_title2"}}', '{"datetime":"2022-01-01T03:18:55.500000Z","providers":[{"name":"ESA","roles":["producer","processor","licensor"],"url":"https:\/\/earth.esa.int\/web\/guest\/home"}],"sat:platform_international_designator":"2016-025A","sat:orbit_state":"ascending","sat:absolute_orbit":17030,"sat:relative_orbit":29,"sat:anx_datetime":"2019-07-07T16:04:33.266062Z","sar:instrument_mode":"IW","sar:frequency_band":"C","sar:center_frequency":5.405,"sar:polarizations":["VV","VH"],"sar:polarization_mode":"D","sar:product_type":"SLC","sar:pixel_spacing_range":2.3,"sar:pixel_spacing_azimuth":14.1,"sar:looks_range":1,"sar:looks_azimuth":1,"sar:looks_equivalent_number":1,"processing:lineage":"SLC Post Processing","processing:facility":"Copernicus S1 Core Ground Segment - UPA","processing:software":{"Sentinel-1 IPF":"003.10"},"s5p:processing_mode":"OFFL","s5p:product_type":"L2__NO2___","s5p:shape":[4173,450],"s5p:spatial_resolution":"5.5x3.5 km2","hcho:geolocation_grid_from_band":3,"hcho:cloud_mode":"crb","no2:irradiance_accompanied":"L1B_IR_UVN","no2:geolocation_grid_from_band":4,"no2:input_band":["L1B_RA_BD4","L2__FRESCO","L2__AER_AI","L2__CLOUD_","L2__O22CLD"],"s1:frame_number":218,"s1:start_anxtime":1090739,"s1:stop_anxtime":1117820,"s1:processing_date":"2019-07-07T18: 33: 12.592265Z","s1:processing_site":"Airbus DS-Newport","s1:ipf_version":3.1,"s1:swaths":["IW1","IW2","IW3"],"s2:product_uri":"S2A_MSIL2A_20201206T073301_N0214_R049_T37MDU_20201206T095713.COG","s2:generation_time":"2020-12-06T09:57:13.000000Z","s2:processing_baseline":"02.14","s2:product_type":"S2MSI2A","s2:datatake_id":"GS2A_20201206T073301_028503_N02.14","s2:datatake_type":"INS-NOBS","s2:datastrip_id":"S2A_OPER_MSI_L2A_DS_VGS1_20201206T095713_S20201206T074838_N02.14","s2:granule_id":"S2A_OPER_MSI_L2A_TL_VGS1_20201206T095713_A028503_T37MDU_N02.14","s2:mgrs_tile":"37MDU","s2:reflectance_conversion_factor":1.02926841547791,"s2:degraded_msi_data_percentage":0,"s2:nodata_pixel_percentage":28.769803,"s2:saturated_defective_pixel_percentage":0,"s2:dark_features_percentage":0.321135,"s2:cloud_shadow_percentage":0.397553,"s2:vegetation_percentage":18.024573,"s2:not_vegetated_percentage":8.802669,"s2:water_percentage":0.000205,"s2:unclassified_percentage":7.487918,"s2:medium_proba_clouds_percentage":7.657396,"s2:high_proba_clouds_percentage":57.241303,"s2:thin_cirrus_percentage":0.063376,"s2:snow_ice_percentage":0.003875,"s2:mean_solar_zenith":29.7984729785585,"s2:mean_solar_azimuth":136.833188288624}');
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoResolution", "atmSpecies", "atmVerticalRange", "extraProperties")
VALUES(2, '2018-02-27 10:20:21.000', '2018-02-27 10:20:21.000', NULL, NULL, NULL, 'SAS1_20180227102021.02', 'SAS1', NULL, 'NOMINAL', 65, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2017-02-26 10:24:58.000', NULL, NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ARRAY['O3', 'NO2'], ARRAY[2000, 500], '{"datetime":"2022-02-01T03:18:55.500000Z","providers":[{"name":"ESA","roles":["producer","processor","licensor"],"url":"https:\/\/earth.esa.int\/web\/guest\/home"}],"sat:platform_international_designator":"2016-025A","sat:orbit_state":"ascending","sat:absolute_orbit":17060,"sat:relative_orbit":29,"sat:anx_datetime":"2019-07-07T16:04:33.266062Z","sar:instrument_mode":"IW","sar:frequency_band":"C","sar:center_frequency":5.405,"sar:polarizations":["VV","VH"],"sar:polarization_mode":"D","sar:product_type":"SLC","sar:pixel_spacing_range":2.3,"sar:pixel_spacing_azimuth":14.1,"sar:looks_range":1,"sar:looks_azimuth":1,"sar:looks_equivalent_number":1,"processing:lineage":"SLC Post Processing","processing:facility":"Copernicus S1 Core Ground Segment - UPA","processing:software":{"Sentinel-1 IPF":"003.10"},"s5p:processing_mode":"OFFL","s5p:product_type":"L2__NO2___","s5p:shape":[4173,450],"s5p:spatial_resolution":"5.5x3.5 km2","hcho:geolocation_grid_from_band":3,"hcho:cloud_mode":"crb","no2:irradiance_accompanied":"L1B_IR_UVN","no2:geolocation_grid_from_band":4,"no2:input_band":["L1B_RA_BD4","L2__FRESCO","L2__AER_AI","L2__CLOUD_","L2__O22CLD"],"s1:frame_number":218,"s1:start_anxtime":1090739,"s1:stop_anxtime":1117820,"s1:processing_date":"2019-07-07T18: 33: 12.592265Z","s1:processing_site":"Airbus DS-Newport","s1:ipf_version":3.1,"s1:swaths":["IW1","IW2","IW3"],"s2:product_uri":"S2A_MSIL2A_20201206T073301_N0214_R049_T37MDU_20201206T095713.COG","s2:generation_time":"2020-12-06T09:57:13.000000Z","s2:processing_baseline":"02.14","s2:product_type":"S2MSI2A","s2:datatake_id":"GS2A_20201206T073301_028503_N02.14","s2:datatake_type":"INS-NOBS","s2:datastrip_id":"S2A_OPER_MSI_L2A_DS_VGS1_20201206T095713_S20201206T074838_N02.13","s2:granule_id":"S2A_OPER_MSI_L2A_TL_VGS1_20201206T095713_A028503_T37MDU_N02.143","s2:mgrs_tile":"37MDU","s2:reflectance_conversion_factor":1.02926841547791,"s2:degraded_msi_data_percentage":0,"s2:nodata_pixel_percentage":28.769803,"s2:saturated_defective_pixel_percentage":0,"s2:dark_features_percentage":0.321135,"s2:cloud_shadow_percentage":0.397553,"s2:vegetation_percentage":18.024573,"s2:not_vegetated_percentage":8.802669,"s2:water_percentage":0.000205,"s2:unclassified_percentage":7.487918,"s2:medium_proba_clouds_percentage":7.657396,"s2:high_proba_clouds_percentage":57.241303,"s2:thin_cirrus_percentage":0.063376,"s2:snow_ice_percentage":0.003875,"s2:mean_solar_zenith":29.7984729785585,"s2:mean_solar_azimuth":136.833188288624}');
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoProductPlatform", "assets")
VALUES(250, '2018-02-27 10:20:21.000', '2018-02-27 10:20:21.000', NULL, NULL, NULL, 'LS8_TEST.02', 'LANDSAT8', NULL, 'NOMINAL', 65, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2017-02-26 10:24:58.000', '2017-02-28 10:24:58.000', NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'LANDSAT_8', '{"thumbnail": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_thumb_large.jpg", "type": "image/jpeg", "title": "Thumbnail", "roles": [ "thumbnail","thumbnail2" ] }, "index": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/index.html", "type": "application/html", "title": "HTML Page" }, "ANG": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_ANG.txt", "type": "text/plain", "title": "ANG Metadata", "roles": [ "metadata" ] }, "MTL": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_MTL.txt", "type": "text/plain", "title": "MTL Metadata", "roles": [ "metadata" ] }, "BQA": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_BQA.TIF", "type": "image/tiff; application=geotiff", "title": "Quality Band", "roles": [ "quality" ] }, "B1": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B1.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B1", "common_name": "coastal", "center_wavelength": 0.48, "full_width_half_max": 0.02 } ] }, "B2": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B2.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B2", "common_name": "blue", "center_wavelength": 0.44, "full_width_half_max": 0.06 } ] }, "B3": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B3.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B3", "common_name": "green", "center_wavelength": 0.56, "full_width_half_max": 0.06 } ] }, "B4": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B4.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B4", "common_name": "red", "center_wavelength": 0.65, "full_width_half_max": 0.04 } ] }, "B5": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B5.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B5", "common_name": "nir", "center_wavelength": 0.86, "full_width_half_max": 0.03 } ] }, "B6": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B6.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B6", "common_name": "swir16", "center_wavelength": 1.6, "full_width_half_max": 0.08 } ] }, "B7": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B7.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B7", "common_name": "swir22", "center_wavelength": 2.2, "full_width_half_max": 0.2 } ] }, "B8": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B8.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B8", "common_name": "pan", "center_wavelength": 0.59, "full_width_half_max": 0.18 } ], "gsd": 15 }, "B9": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B9.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B9", "common_name": "cirrus", "center_wavelength": 1.37, "full_width_half_max": 0.02 } ] }, "B10": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B10.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B10", "common_name": "lwir11", "center_wavelength": 10.9, "full_width_half_max": 0.8 } ], "gsd": 100 }, "B11": { "href": "https://landsat-pds.s3.us-west-2.amazonaws.com/c1/L8/218/077/LC08_L1TP_218077_20210511_20210511_01_T1/LC08_L1TP_218077_20210511_20210511_01_T1_B11.TIF", "type": "image/tiff; application=geotiff; profile=cloud-optimized", "eo:bands": [ { "name": "B11", "common_name": "lwir12", "center_wavelength": 12, "full_width_half_max": 1 } ], "gsd": 100 }}');
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoProductPlatform", "enabled")
VALUES(251, '2018-02-27 10:20:21.000', '2018-02-27 10:20:21.000', NULL, NULL, NULL, 'LS8_TEST.DISABLED', 'LANDSAT8', NULL, 'NOMINAL', 65, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2017-02-26 10:24:58.000', '2017-02-28 10:24:58.000', NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'LANDSAT_8', false);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoProductPlatform", "enabled")
VALUES(252, '2018-02-27 10:20:21.000', '2018-02-27 10:20:21.000', NULL, NULL, NULL, 'PRODUCT.IN.DISABLED.COLLECTION', 'DISABLED_COLLECTION', NULL, 'NOMINAL', 65, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2017-02-26 10:24:58.000', '2017-02-28 10:24:58.000', NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'LANDSAT_8', true);
INSERT INTO product
("id", "timeStart", "timeEnd", "originalPackageLocation", "thumbnailURL", "quicklookURL", "eoIdentifier", "eoParentIdentifier", "eoProductionStatus", "eoAcquisitionType", "eoOrbitNumber", "eoOrbitDirection", "eoTrack", "eoFrame", "eoSwathIdentifier", "optCloudCover", "optSnowCover", "eoProductQualityStatus", "eoProductQualityDegradationStatus", "eoProcessorName", "eoProcessingCenter", "eoCreationDate", "eoModificationDate", "eoProcessingDate", "eoSensorMode", "eoArchivingCenter", "eoProcessingMode", "eoAvailabilityTime", "eoAcquisitionStation", "eoAcquisitionSubtype", "eoStartTimeFromAscendingNode", "eoCompletionTimeFromAscendingNode", "eoIlluminationAzimuthAngle", "eoIlluminationZenithAngle", "eoIlluminationElevationAngle", "sarPolarisationMode", "sarPolarisationChannels", "sarAntennaLookDirection", "sarMinimumIncidenceAngle", "sarMaximumIncidenceAngle", "sarDopplerFrequency", "sarIncidenceAngleVariation", "eoProductPlatform", "assets","assetsb")
VALUES(253, '2018-02-27 10:20:21.000', '2018-02-27 10:20:21.000', NULL, NULL, NULL, 'JSONB_TEST.02', 'LANDSAT8', NULL, 'NOMINAL', 65, 'DESCENDING', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2017-02-26 10:24:58.000', '2017-02-28 10:24:58.000', NULL, NULL, 'DPA', 'DATA_DRIVEN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'LANDSAT_8', '{"g":1,"m":2,"f":3,"h":4,"c":5,"a":{"hello":6,"archive":7,"meh":{"working":8,"aver":9}},"opt:cloudCover":34}','{"g":1,"m":2,"f":3,"h":4,"c":5,"a":{"hello":6,"archive":7,"meh":{"working":8,"aver":9}},"opt:cloudCover":34}');
-- setup sequence to allow new inserts
select setval('product_id_seq'::regclass, 400);
-- geometries
update product set "footprint" = ST_GeomFromText('POLYGON((11.5838082795702 43.2356009596972,11.6266459737 44.2232097399754,10.2524808722177 44.2465509344875,10.2320327000367 43.2581553186329,11.5838082795702 43.2356009596972))', 4326) where "id" = 352;
update product set "footprint" = ST_GeomFromText('POLYGON((11.4771981216025 40.5361855279791,11.5145383905836 41.5243446964658,10.1989696147851 41.5455937685231,10.1811479284525 40.5567117421899,11.4771981216025 40.5361855279791))', 4326) where "id" = 353;
update product set "footprint" = ST_GeomFromText('POLYGON((11.511136546877 41.4363363796466,11.5502129332041 42.424314136601,10.2159970226689 42.446240862199,10.1973459574064 41.4575201914604,11.511136546877 41.4363363796466))', 4326) where "id" = 354;
update product set "footprint" = ST_GeomFromText('POLYGON((11.54663057229 42.3357822388091,11.5875361840958 43.3235765959035,10.2338121377569 43.3462000093822,10.2142871341731 42.357641452722,11.54663057229 42.3357822388091))', 4326) where "id" = 355;
update product set "footprint" = ST_GeomFromText('POLYGON((12.6555550144012 40.5048858361439,12.7105746486792 41.4919436335118,11.3967035858509 41.5268622910048,11.3611090420914 40.5386175014828,12.6555550144012 40.5048858361439))', 4326) where "id" = 356;
update product set "footprint" = ST_GeomFromText('POLYGON((12.7055622985457 41.4040347456695,12.7631364327153 42.390880661933,11.4307104530236 42.4269119955201,11.3934607768259 41.4388462443458,12.7055622985457 41.4040347456695))', 4326) where "id" = 357;
update product set "footprint" = ST_GeomFromText('POLYGON((12.7578584453313 42.3024516150967,12.8181237037037 43.2890817986998,11.4662891411211 43.3262569713208,11.4272955487421 42.3383721014377,12.7578584453313 42.3024516150967))', 4326) where "id" = 358;
update product set "footprint" = ST_GeomFromText('POLYGON((12.7538138816071 40.5409099943834,12.7199481155048 41.529235500269,11.4058754481675 41.4956464353069,11.4591773974708 40.5084628254068,12.7538138816071 40.5409099943834))', 4326) where "id" = 359;
update product set "footprint" = ST_GeomFromText('POLYGON((12.7230334326741 41.441212166537,12.6875927586133 42.4293608719057,11.354954233769 42.3947013936827,11.4107313321493 41.4077261896606,12.7230334326741 41.441212166537))', 4326) where "id" = 360;
update product set "footprint" = ST_GeomFromText('POLYGON((13.9345845243305 40.5578370988168,13.9185081926205 41.5467587694457,12.6028173807889 41.5268523010436,12.6384190226498 40.5386078512833,13.9345845243305 40.5578370988168))', 4326) where "id" = 361;
update product set "footprint" = ST_GeomFromText('POLYGON((13.9199728398341 41.4586816132041,13.9031483158175 42.4474430295132,12.5688037328127 42.4269016870524,12.6060608364496 41.4388362850582,13.9199728398341 41.4586816132041))', 4326) where "id" = 362;
update product set "footprint" = ST_GeomFromText('POLYGON((13.9046907528374 42.3588399172532,13.8870778350269 43.3474403883678,12.5332179512316 43.3262463354083,12.5722193179788 42.3383618247011,13.9046907528374 42.3588399172532))', 4326) where "id" = 363;
update product set "footprint" = ST_GeomFromText('POLYGON((15.1152915645278 40.5626923867805,15.1170316343884 41.5517851164402,13.8005508983712 41.5455887675521,13.8183797078051 40.5567069113961,15.1152915645278 40.5626923867805))', 4326) where "id" = 364;
update product set "footprint" = ST_GeomFromText('POLYGON((15.116873103165 41.4636925165252,15.1186941736231 42.4526297452823,13.7835166850224 42.4462357016878,13.8021752046975 41.4575152058534,15.116873103165 41.4636925165252))', 4326) where "id" = 365;
update product set "footprint" = ST_GeomFromText('POLYGON((15.118527220871 42.3640106558655,15.1204336460529 43.3527919847601,13.765694449825 43.3461946848441,13.7852272569138 42.3576363081053,15.118527220871 42.3640106558655))', 4326) where "id" = 366;
update product set "footprint" = ST_GeomFromText('POLYGON((16.3144181193426 41.4562418971277,16.3348915668768 42.4449177238751,14.9997567739808 42.4526911986963,14.9997605056969 41.4637518867081,16.3144181193426 41.4562418971277))', 4326) where "id" = 367;
update product set "footprint" = ST_GeomFromText('POLYGON((16.3330146087991 42.3563223896204,16.3544473299751 43.3448348160069,14.999753209474 43.3528553918882,14.9997571160984 42.3640719199627,16.3330146087991 42.3563223896204))', 4326) where "id" = 368;
update product set "footprint" = ST_GeomFromText('POLYGON((-117.969375418501 33.347577737731,-117.980622432928 34.3377366075886,-119.173780060482 34.3223655296285,-119.148867136577 33.3327671071438,-117.969375418501 33.347577737731))', 4326) where "id" = 369;
update product set "footprint" = ST_GeomFromText('POLYGON((11.54663057229 42.3357822388091,11.5875361840958 43.3235765959035,10.2338121377569 43.3462000093822,10.2142871341731 42.357641452722,11.54663057229 42.3357822388091))', 4326) where "id" = 370;
update product set "footprint" = ST_GeomFromText('POLYGON((-180 -90, 180 -90, 180 90, -180 90, -180 -90))', 4326) where "id" = 1;
update product set "footprint" = ST_GeomFromText('POLYGON((-180 -90, 180 -90, 180 90, -180 90, -180 -90))', 4326) where "id" = 2;
update product set "footprint" = ST_GeomFromText('POLYGON((-180 -90, 180 -90, 180 90, -180 90, -180 -90))', 4326) where "id" = 250;
update product set "footprint" = ST_GeomFromText('POLYGON((-180 -90, 180 -90, 180 90, -180 90, -180 -90))', 4326) where "id" = 251;
update product set "footprint" = ST_GeomFromText('POLYGON((-180 -90, 180 -90, 180 90, -180 90, -180 -90))', 4326) where "id" = 252;
update product set "footprint" = ST_GeomFromText('POLYGON((-180 -90, 180 -90, 180 90, -180 90, -180 -90))', 4326) where "id" = 253;
-- thumbs for just one product
INSERT INTO product_thumb
("tid", "thumb")
VALUES(368, E'\\xffd8ffe000104a46494600010101004800480000ffe20be04943435f50524f46494c4500010100000bd04c696e6f021000006d6e74725247422058595a2007ce00020009000600310000616373704d5346540000000049454320735247420000000000000000000000000000f6d6000100000000d32d4850202000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e637072740000012c0000003364657363000001600000006c77747074000001cc00000014626b7074000001e0000000147258595a000001f4000000146758595a00000208000000146258595a0000021c00000014646d6e640000023000000070646d6464000002a0000000887675656400000328000000866c756d69000003b00000001472545243000003c40000080c67545243000003c40000080c62545243000003c40000080c7465787400000000436f70797269676874202863292031393938204865776c6574742d5061636b61726420436f6d70616e790000646573630000000000000012735247422049454336313936362d322e31000000000000000000000012735247422049454336313936362d322e31000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000058595a20000000000000f35100010000000116cc58595a200000000000000000000000000000000058595a200000000000006fa2000038f50000039058595a2000000000000062990000b785000018da58595a2000000000000024a000000f840000b6cf64657363000000000000001649454320687474703a2f2f7777772e6965632e636800000000000000000000001649454320687474703a2f2f7777772e6965632e63680000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000064657363000000000000002e4945432036313936362d322e312044656661756c742052474220636f6c6f7572207370616365202d207352474200000000000000000000002e4945432036313936362d322e312044656661756c742052474220636f6c6f7572207370616365202d20735247420000000000000000000000000000000000000000000064657363000000000000002c5265666572656e63652056696577696e6720436f6e646974696f6e20696e2049454336313936362d322e3100000000000000000000002c5265666572656e63652056696577696e6720436f6e646974696f6e20696e2049454336313936362d322e31000000000000000000000000000000000000000000000000000058595a2000000000004c09560050000000571fe763757276000000000000040000000005000a000f00140019001e00230028002d00320037003b00400045004a004f00540059005e00630068006d00720077007c00810086008b00900095009a009f00a400a900ae00b200b700bc00c100c600cb00d000d500db00e000e500eb00f000f600fb01010107010d01130119011f0125012b01320138013e0145014c0152015901600167016e0175017c0183018b0192019a01a101a901b101b901c101c901d101d901e101e901f201fa0203020c0214021d0226022f02380241024b0254025d02670271027a0284028e029802a202ac02b602c102cb02d502e002eb02f50300030b03160321032d03380343034f035a03660372037e038a039603a203ae03ba03c703d303e003ec03f9040604130420042d043b0448045504630471047e048c049a04a804b604c404d304e104f004fe050d051c052b053a05490558056705770586059605a605b505c505d505e505f6060606160627063706480659066a067b068c069d06af06c006d106e306f507070719072b073d074f076107740786079907ac07bf07d207e507f8080b081f08320846085a086e0882089608aa08be08d208e708fb09100925093a094f09640979098f09a409ba09cf09e509fb0a110a270a3d0a540a6a0a810a980aae0ac50adc0af30b0b0b220b390b510b690b800b980bb00bc80be10bf90c120c2a0c430c5c0c750c8e0ca70cc00cd90cf30d0d0d260d400d5a0d740d8e0da90dc30dde0df80e130e2e0e490e640e7f0e9b0eb60ed20eee0f090f250f410f5e0f7a0f960fb30fcf0fec1009102610431061107e109b10b910d710f511131131114f116d118c11aa11c911e81207122612451264128412a312c312e31303132313431363138313a413c513e5140614271449146a148b14ad14ce14f01512153415561578159b15bd15e0160316261649166c168f16b216d616fa171d17411765178917ae17d217f7181b18401865188a18af18d518fa19201945196b199119b719dd1a041a2a1a511a771a9e1ac51aec1b141b3b1b631b8a1bb21bda1c021c2a1c521c7b1ca31ccc1cf51d1e1d471d701d991dc31dec1e161e401e6a1e941ebe1ee91f131f3e1f691f941fbf1fea20152041206c209820c420f0211c2148217521a121ce21fb22272255228222af22dd230a23382366239423c223f0241f244d247c24ab24da250925382568259725c725f726272657268726b726e827182749277a27ab27dc280d283f287128a228d429062938296b299d29d02a022a352a682a9b2acf2b022b362b692b9d2bd12c052c392c6e2ca22cd72d0c2d412d762dab2de12e162e4c2e822eb72eee2f242f5a2f912fc72ffe3035306c30a430db3112314a318231ba31f2322a3263329b32d4330d3346337f33b833f1342b3465349e34d83513354d358735c235fd3637367236ae36e937243760379c37d738143850388c38c839053942397f39bc39f93a363a743ab23aef3b2d3b6b3baa3be83c273c653ca43ce33d223d613da13de03e203e603ea03ee03f213f613fa23fe24023406440a640e74129416a41ac41ee4230427242b542f7433a437d43c044034447448a44ce45124555459a45de4622466746ab46f04735477b47c04805484b489148d7491d496349a949f04a374a7d4ac44b0c4b534b9a4be24c2a4c724cba4d024d4a4d934ddc4e254e6e4eb74f004f494f934fdd5027507150bb51065150519b51e65231527c52c75313535f53aa53f65442548f54db5528557555c2560f565c56a956f75744579257e0582f587d58cb591a596959b85a075a565aa65af55b455b955be55c355c865cd65d275d785dc95e1a5e6c5ebd5f0f5f615fb36005605760aa60fc614f61a261f56249629c62f06343639763eb6440649464e9653d659265e7663d669266e8673d679367e9683f689668ec6943699a69f16a486a9f6af76b4f6ba76bff6c576caf6d086d606db96e126e6b6ec46f1e6f786fd1702b708670e0713a719571f0724b72a67301735d73b87414747074cc7528758575e1763e769b76f8775677b37811786e78cc792a798979e77a467aa57b047b637bc27c217c817ce17d417da17e017e627ec27f237f847fe5804780a8810a816b81cd8230829282f4835783ba841d848084e3854785ab860e867286d7873b879f8804886988ce8933899989fe8a648aca8b308b968bfc8c638cca8d318d988dff8e668ece8f368f9e9006906e90d6913f91a89211927a92e3934d93b69420948a94f4955f95c99634969f970a977597e0984c98b89924999099fc9a689ad59b429baf9c1c9c899cf79d649dd29e409eae9f1d9f8b9ffaa069a0d8a147a1b6a226a296a306a376a3e6a456a4c7a538a5a9a61aa68ba6fda76ea7e0a852a8c4a937a9a9aa1caa8fab02ab75abe9ac5cacd0ad44adb8ae2daea1af16af8bb000b075b0eab160b1d6b24bb2c2b338b3aeb425b49cb513b58ab601b679b6f0b768b7e0b859b8d1b94ab9c2ba3bbab5bb2ebba7bc21bc9bbd15bd8fbe0abe84beffbf7abff5c070c0ecc167c1e3c25fc2dbc358c3d4c451c4cec54bc5c8c646c6c3c741c7bfc83dc8bcc93ac9b9ca38cab7cb36cbb6cc35ccb5cd35cdb5ce36ceb6cf37cfb8d039d0bad13cd1bed23fd2c1d344d3c6d449d4cbd54ed5d1d655d6d8d75cd7e0d864d8e8d96cd9f1da76dafbdb80dc05dc8add10dd96de1cdea2df29dfafe036e0bde144e1cce253e2dbe363e3ebe473e4fce584e60de696e71fe7a9e832e8bce946e9d0ea5beae5eb70ebfbec86ed11ed9cee28eeb4ef40efccf058f0e5f172f1fff28cf319f3a7f434f4c2f550f5def66df6fbf78af819f8a8f938f9c7fa57fae7fb77fc07fc98fd29fdbafe4bfedcff6dffffffdb00430006040506050406060506070706080a100a0a09090a140e0f0c1017141818171416161a1d251f1a1b231c1616202c20232627292a29191f2d302d283025282928ffdb0043010707070a080a130a0a13281a161a2828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828282828ffc00011080040004003012200021101031101ffc400190001000301010000000000000000000000000406070503ffc4002e1000020103020404040700000000000000000102030411052106123141135161b1223252917181a1b2c1d1e1ffc40017010101010100000000000000000000000000030104ffc4001a110101010101010100000000000000000000011103023121ffda000c03010002110311003f00c492529a71eaba6fdcf2c6f88aea4fbaa71a5053a5521cb34a4a3cce52eebc963bff00a45934e29c3e65d517c732adc455bc4bd8c3e88adbd5effd1ca3defab3b8bcad55bcf3cdbfc8f0236ed74499300018d000068f77415bbe4e5db3d5aea40d4a4e8697735124b9638cfe3b2fd59da7177aa729662f11c2ed2f5fb15be2fba953b285a492539d4e6963c917f5722126d54400417000000006c3a1d8395b4ae799ba71c41c71df0dafda5038eabaabaf4e94649c684230dbcfabf7343d0352a56ba35c49fc53524e4b6d92efe7ddf46647a8dd4afb50b9baa9f3d6a92a8f6c75792bd7ea7cfe2300092800000000b75fde4ed74eb8e4787523e1fdf6f6c9513b7c4357e1a5497ac9fb2fe4e216ef77d27ce7e00022a000000003ffd9');
-- ogc links
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(5881, 352, 'http://www.opengis.net/spec/owc/1.0/req/atom/wms', 'GET', 'GetCapabilities', 'application/xml', '${BASE_URL}/sentinel2/ows?service=wms&version=1.3.0&request=GetCapabilities', 5881, 5881.1, true, '2017-01-01', '5881');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(5882, 352, 'http://www.opengis.net/spec/owc/1.0/req/atom/wms', 'GET', 'GetMap', 'image/jpeg', '${BASE_URL}/sentinel2/wms?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&FORMAT=image%2Fjpeg&STYLES&LAYERS=sentinel2%3Asentinel2-TCI&SRS=EPSG%3A4326&WIDTH=800&HEIGHT=600&BBOX=10.2320327000367%2C43.2356009596972%2C11.6266459737%2C44.2465509344875', 5882, 5882.1, true, '2017-01-01', '5882');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(5883, 352, 'http://www.opengis.net/spec/owc/1.0/req/atom/wmts', 'GET', 'GetCapabilities', 'application/xml', '${BASE_URL}/sentinel2/gwc/service/wmts?REQUEST=GetCapabilities', 5883, 5883.1, true, '2017-01-01', '5883');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(5884, 352, 'http://www.opengis.net/spec/owc/1.0/req/atom/wmts', 'GET', 'GetTile', 'image/jpeg', '${BASE_URL}/sentinel2/gwc/service/wmts?layer=sentinel2%3ATCI&style&tilematrixset=EPSG%3A4326&Service=WMTS&Request=GetTile&Version=1.0.0&Format=image%2Fjpeg&TileMatrix=EPSG%3A4326%3A13&TileCol=7780&TileRow=2248', 5884, 5884.1, true, '2017-01-01', '5884');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(5885, 352, 'http://www.opengis.net/spec/owc/1.0/req/atom/wcs', 'GET', 'GetCapabilities', 'application/xml', '${BASE_URL}/sentinel2/ows?service=WCS&version=2.0.1&request=GetCapabilities', 5885, 5885.1, true, '2017-01-01', '5885');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(5886, 352, 'http://www.opengis.net/spec/owc/1.0/req/atom/wcs', 'GET', 'GetCoverage', 'image/tiff', '${BASE_URL}/sentinel2/ows?service=WCS&version=2.0&request=GetCoverage&coverageid=sentinel2%3Asentinel2-TCI&format=image%2Fgeotiff', 5886, 5886.1, true, '2017-01-01', '5886');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(6881, 353, 'http://www.opengis.net/spec/owc/1.0/req/atom/wms', 'GET', 'GetCapabilities', 'application/xml', '${BASE_URL}/sentinel2/ows?service=wms&version=1.3.0&request=GetCapabilities', 6881, 6881.1, true, '2017-01-01', '6881text');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(6882, 353, 'http://www.opengis.net/spec/owc/1.0/req/atom/wms', 'GET', 'GetMap', 'image/jpeg', '${BASE_URL}/sentinel2/wms?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&FORMAT=image%2Fjpeg&STYLES&LAYERS=sentinel2%3Asentinel2-TCI&SRS=EPSG%3A4326&WIDTH=800&HEIGHT=600&BBOX=10.2320327000367%2C43.2356009596972%2C11.6266459737%2C44.2465509344875', 6882, 6882.1, true, '2017-01-01', '6882');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(6883, 353, 'http://www.opengis.net/spec/owc/1.0/req/atom/wmts', 'GET', 'GetCapabilities', 'application/xml', '${BASE_URL}/sentinel2/gwc/service/wmts?REQUEST=GetCapabilities', 6883, 6883.1, true, '2017-01-01', '6883');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(6884, 353, 'http://www.opengis.net/spec/owc/1.0/req/atom/wmts', 'GET', 'GetTile', 'image/jpeg', '${BASE_URL}/sentinel2/gwc/service/wmts?layer=sentinel2%3ATCI&style&tilematrixset=EPSG%3A4326&Service=WMTS&Request=GetTile&Version=1.0.0&Format=image%2Fjpeg&TileMatrix=EPSG%3A4326%3A13&TileCol=7780&TileRow=2248', 6884, 6884.1, true, '2017-01-01', '6884');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(6885, 353, 'http://www.opengis.net/spec/owc/1.0/req/atom/wcs', 'GET', 'GetCapabilities', 'application/xml', '${BASE_URL}/sentinel2/ows?service=WCS&version=2.0.1&request=GetCapabilities', 6885, 6885.1, true, '2017-01-01', '6885');
INSERT INTO public.product_ogclink
("lid", "product_id", "offering", "method", "code", "type", "href", "intTest", "floatTest", "booleanTest", "dateTest", "varcharTest")
VALUES(6886, 353, 'http://www.opengis.net/spec/owc/1.0/req/atom/wcs', 'GET', 'GetCoverage', 'image/tiff', '${BASE_URL}/sentinel2/ows?service=WCS&version=2.0&request=GetCoverage&coverageid=sentinel2%3Asentinel2-TCI&format=image%2Fgeotiff', 6886, 6886.1, true, '2017-01-01', '6886');
-- download links
update product set "originalPackageLocation" = '${BASE_URL}/scihub/sentinel2/S2A_OPER_MSI_L1C_TL_SGS__20160929T154211_A006640_T32TPP_N02.04.zip', "originalPackageType" = 'application/zip' where "id" = 352;
update product set "originalPackageLocation" = '${BASE_URL}/scihub/sentinel2/S2A_OPER_MSI_L1C_TL_SGS__20160117T141030_A002979_T32TPL_N02.01.zip' where "id" = 353;
